package com.ky.home.mapper;

import com.ky.home.entity.Baolubi;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ky.home.entity.Fenshuxian;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lgh
 * @since 2024-06-20
 */
public interface BaolubiMapper extends BaseMapper<Baolubi> {

    @Select( "SELECT * FROM baolubi WHERE year >= YEAR(CURRENT_DATE) - 3 AND school_name =#{schoolName} ;")
    List<Baolubi> selectBySchoolName(String schoolName);
}
